2016-01-27 - 24445.100 - Spec - Web invoice returns generator #CrystalReportDevelopment
SPECIFICATIONS
24445.100 - Web Invoice returns generator
Purpose
Need to develop a new report that should start with the web returns process and it should run for last 6 months for all invoices where reference numbers starts with WEB*.
Admin Info
Purpose
|
Need to develop a new report that should start with the web returns process and it should run for last 6 months for all invoices where reference numbers starts with WEB*
|
Requested By
|
Craig Spangler
|
Spec Created By
|
Venkateswara Reddy D
|
Spec Created Date
|
01/27/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZAFSDDS1 and ZSD_O06 DSOs
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
20
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
08
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email from Saravanan on 01/21/2016:
Can you please look at the fields below(last line of the email) and let me know whether they are available in BW ? If so, then we can proceed further.
This is what we need for the report to start the web returns process. Report Run for last 6 months all invoices on where Reference number starts with WEB*. If you can think of a better way to identify them let me know, they are on the same company code as other UK Orders 0030 so this is my best idea. Invoice Number, Reference (Web Order Number), Assignment (Delivery Number),Material ID, Size, Invoice Item Number.
In Scope:
All fields available as per reporting requirement.
Out of Scope:
None
Solution Summary
1
. Need to identify the available fields in BW DSOs.
2. Need to connect to the crystal designer and join BW DSOs.
3. Need to establish the joins between DSOs.
4. Need to code new logic to pull data for past six months.
5. Need to restrict the data for WEB orders only.
6. Need to validate the data after the joins.
Solution Details
1
. All the required fields are available in ZSD_O06 & ZAFSDDS1 BW DSOs.
2. Need to connect to the crystal designer and join BW DSOs.
3. Need to establish the joins between DSOs.
4. Need to code new logic to pull data for past six months.
5
. Need to restrict the Purchasing document type to WEB.
6. Need to validate the report after successful development.
Issues
Huge volume of records in the AFS Sales Order DSO and Billing Document Item DSO may cause the report performance issue.